# 运行脚本前在E盘下建立文件夹  example\01\测试数据表\
import xlwings as xw 
app = xw.App(visible= True, add_book = False)
for i in range(1, 21):
    workbook = app.books.add()
    workbook.save(f'e:\\example\\01\\测试数据表\\测试{i}.xlsx')
    workbook.close()
app.quit()